/*
 Navicat Premium Data Transfer

 Source Server         : MySql
 Source Server Type    : MySQL
 Source Server Version : 50716
 Source Host           : localhost
 Source Database       : hzyj

 Target Server Type    : MySQL
 Target Server Version : 50716
 File Encoding         : utf-8

 Date: 09/06/2020 17:28:54 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `message_logs`
-- ----------------------------
DROP TABLE IF EXISTS `message_logs`;
CREATE TABLE `message_logs` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mobile` varchar(20) DEFAULT NULL COMMENT '手机号',
  `area` varchar(20) DEFAULT NULL COMMENT '点位区域',
  `position` varchar(20) DEFAULT NULL COMMENT '点位位置',
  `grade` varchar(20) DEFAULT NULL COMMENT '风险等级',
  `time` datetime DEFAULT NULL COMMENT '发送时间',
  PRIMARY KEY (`id`),
  KEY `time` (`time`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `message_logs`
-- ----------------------------
BEGIN;
INSERT INTO `message_logs` VALUES ('1', '13001274581', '分拣区1（南柱子）（普通烟）', '2号包装机电源', '低风险', '2020-06-16 12:31:30'), ('2', '13001274581', '分拣区1（南柱子）（普通烟）', '2号分拣线电源', '低风险', '2020-06-16 12:31:30'), ('3', '13001274581', '分拣区1（南柱子）（普通烟）', '1号分拣线电源', '低风险', '2020-06-16 12:31:30'), ('4', '13001274581', '分拣区2（北柱子）（异型烟）', '3号包装机电源', '低风险', '2020-06-16 12:31:30'), ('5', '13001274581', '分拣区2（北柱子）（异型烟）', '4号包装机电源', '低风险', '2020-06-16 12:31:30'), ('6', '13001274581', '分拣区2（北柱子）（异型烟）', '异型烟分拣机电源', '低风险', '2020-06-16 12:31:30'), ('7', '13001274581', '分拣区2（北柱子）（异型烟）', '4号分拣线电源', '低风险', '2020-06-16 12:31:30'), ('8', '13001274581', '分拣区2（北柱子）（异型烟）', '3号分拣线电源', '低风险', '2020-06-16 12:31:30'), ('9', '13001274581', '昆船配电柜', '主控制柜', '低风险', '2020-06-16 12:31:30'), ('10', '13001274581', '昆船配电柜', '机器人1', '低风险', '2020-06-16 12:31:30'), ('11', '13001274581', '昆船配电柜', '堆垛机1', '低风险', '2020-06-16 12:31:30'), ('12', '13001274581', '昆船配电柜', '堆垛机2', '低风险', '2020-06-16 12:31:31'), ('13', '13001274581', '昆船配电柜', '堆垛机3', '低风险', '2020-06-16 12:31:31'), ('14', '13001274581', '昆船配电柜', '堆垛机4', '低风险', '2020-06-16 12:31:31'), ('15', '13001274581', '空压机房', '空压机01', '低风险', '2020-06-16 12:31:31'), ('16', '13001274581', '空压机房', '空压机02', '低风险', '2020-06-16 12:31:31'), ('17', '13001274581', '变压器室', '变压器室', '低风险', '2020-06-16 12:31:31'), ('18', '13001274581', 'C类烟库及异型烟打码区', 'C类烟库01', '低风险', '2020-06-16 12:31:31'), ('19', '13001274581', 'C类烟库及异型烟打码区', 'C类烟库02', '低风险', '2020-06-16 12:31:31'), ('20', '13001274581', 'UPS电源室（二楼）', 'UPS电源室（二楼）', '低风险', '2020-06-16 12:31:31'), ('21', '13001274581', '低压变电室（二楼）', '低压变电室01', '低风险', '2020-06-16 12:31:31'), ('22', '13001274581', '低压变电室（二楼）', '低压变电室02', '低风险', '2020-06-16 12:31:31'), ('23', '13001274581', '变电所', '高压配电室01', '低风险', '2020-06-16 12:31:31'), ('24', '13001274581', '变电所', '高压配电室02', '低风险', '2020-06-16 12:31:31'), ('25', '13001274581', '水泵房', '水泵房', '低风险', '2020-06-16 12:31:31'), ('26', '13001274581', '高架库与分拣区墙（分拣区）南', '高架库与分拣区墙（分拣区）南', '低风险', '2020-06-16 12:31:31'), ('27', '13001274581', '高架库与分拣区墙（分拣区）中', '高架库与分拣区墙（分拣区）中', '低风险', '2020-06-16 12:31:31'), ('28', '13001274581', '高架库与分拣区墙（分拣区）北', '高架库与分拣区墙（分拣区）北', '低风险', '2020-06-16 12:31:31'), ('29', '13001274581', '高架库与分拣区墙（高架区）（北）', '高架库与分拣区墙（高架区）（北）', '低风险', '2020-06-16 12:31:31'), ('30', '13001274581', '高架库与分拣区墙（高架区）（南）', '高架库与分拣区墙（高架区）（南）', '低风险', '2020-06-16 12:31:31'), ('31', '13001274581', '高架库与外墙（南）', '高架库与外墙（南）', '低风险', '2020-06-16 12:31:31');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
